Dataset info
| Number of variables | 51 |
|---|---|
| Number of observations | 462298 |
| Missing cells | 2183512 (9.3%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 179.9 MiB |
| Average record size in memory | 408.0 B |
Variables types
| Numeric | 12 |
|---|---|
| Categorical | 17 |
| Boolean | 15 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 6 |
| Unsupported | 0 |
Warnings
de_faixa_faturamento_estimado has 27513 (6.0%) missing values | Missing |
de_faixa_faturamento_estimado_grupo has 27513 (6.0%) missing values | Missing |
de_natureza_juridica has a high cardinality: 67 distinct values | Warning |
de_nivel_atividade has 11168 (2.4%) missing values | Missing |
de_saude_rescencia has 14851 (3.2%) missing values | Missing |
de_saude_tributaria has 14851 (3.2%) missing values | Missing |
dt_situacao has a high cardinality: 7335 distinct values | Warning |
empsetorcensitariofaixarendapopulacao has 143829 (31.1%) missing values | Missing |
fl_optante_simei is highly correlated with fl_mei (ρ = 0.9579210437) | Rejected |
fl_optante_simples has 82713 (17.9%) missing values | Missing |
idade_maxima_socios has 151602 (32.8%) missing values | Missing |
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.9568741341) | Rejected |
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.9533591208) | Rejected |
nm_divisao has a high cardinality: 88 distinct values | Warning |
nm_meso_regiao has 58698 (12.7%) missing values | Missing |
nm_micro_regiao has a high cardinality: 74 distinct values | Warning |
nm_micro_regiao has 58698 (12.7%) missing values | Missing |
nu_meses_rescencia has 45276 (9.8%) missing values | Missing |
qt_filiais has 418043 (90.4%) zeros | Zeros |
qt_socios is highly skewed (γ1 = 27.25083606) | Skewed |
qt_socios has 115091 (24.9%) missing values | Missing |
qt_socios_feminino is highly skewed (γ1 = 76.48075241) | Skewed |
qt_socios_feminino has 317269 (68.6%) missing values | Missing |
qt_socios_masculino is highly correlated with qt_socios (ρ = 0.9632367436) | Rejected |
qt_socios_pf is highly correlated with qt_socios_masculino (ρ = 0.9652540624) | Rejected |
qt_socios_pj has 342663 (74.1%) zeros | Zeros |
qt_socios_pj has 115091 (24.9%) missing values | Missing |
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.9883617721) | Rejected |
vl_faturamento_estimado_aux is highly skewed (γ1 = 329.062977) | Skewed |
vl_faturamento_estimado_aux has 27513 (6.0%) missing values | Missing |
vl_faturamento_estimado_grupo_aux is highly skewed (γ1 = 26.79710656) | Skewed |
vl_faturamento_estimado_grupo_aux has 27513 (6.0%) missing values | Missing |
vl_total_veiculos_leves_grupo is highly skewed (γ1 = 34.48790893) | Skewed |
vl_total_veiculos_leves_grupo has 424180 (91.8%) zeros | Zeros |
vl_total_veiculos_pesados_grupo is highly skewed (γ1 = 31.26208196) | Skewed |
vl_total_veiculos_pesados_grupo has 441360 (95.5%) zeros | Zeros |
de_faixa_faturamento_estimado
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.0% |
| Missing (n) | 27513 |
| DE R$ 81.000,01 A R$ 360.000,00 | |
|---|---|
| ATE R$ 81.000,00 | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | 46225 |
| Other values (9) | 16141 |
| (Missing) | 27513 |
| Value | Count | Frequency (%) | |
| DE R$ 81.000,01 A R$ 360.000,00 | 273861 | 59.2% | |
| ATE R$ 81.000,00 | 98558 | 21.3% | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | 46225 | 10.0% | |
| DE R$ 1.500.000,01 A R$ 4.800.000,00 | 10153 | 2.2% | |
| DE R$ 4.800.000,01 A R$ 10.000.000,00 | 2150 | 0.5% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 1445 | 0.3% | |
| SEM INFORMACAO | 1173 | 0.3% | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 871 | 0.2% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 253 | 0.1% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 48 | < 0.1% | |
| Other values (2) | 48 | < 0.1% | |
| (Missing) | 27513 | 6.0% |
| Max length | 40 |
|---|---|
| Mean length | 26.5734072 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_faixa_faturamento_estimado_grupo
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.0% |
| Missing (n) | 27513 |
| DE R$ 81.000,01 A R$ 360.000,00 | |
|---|---|
| ATE R$ 81.000,00 | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | |
| Other values (8) | 30573 |
| (Missing) | 27513 |
| Value | Count | Frequency (%) | |
| DE R$ 81.000,01 A R$ 360.000,00 | 252602 | 54.6% | |
| ATE R$ 81.000,00 | 98118 | 21.2% | |
| DE R$ 360.000,01 A R$ 1.500.000,00 | 53492 | 11.6% | |
| DE R$ 1.500.000,01 A R$ 4.800.000,00 | 13465 | 2.9% | |
| DE R$ 4.800.000,01 A R$ 10.000.000,00 | 4055 | 0.9% | |
| ACIMA DE 1 BILHAO DE REAIS | 3613 | 0.8% | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 3598 | 0.8% | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 3061 | 0.7% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 1583 | 0.3% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 676 | 0.1% | |
| (Missing) | 27513 | 6.0% |
| Max length | 40 |
|---|---|
| Mean length | 26.8179248 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_natureza_juridica
Categorical
| Distinct count | 67 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| EMPRESARIO INDIVIDUAL | |
|---|---|
| SOCIEDADE EMPRESARIA LIMITADA | |
| ASSOCIACAO PRIVADA | 29694 |
| Other values (64) | 45617 |
| Value | Count | Frequency (%) | |
| EMPRESARIO INDIVIDUAL | 295756 | 64.0% | |
| SOCIEDADE EMPRESARIA LIMITADA | 91231 | 19.7% | |
| ASSOCIACAO PRIVADA | 29694 | 6.4% | |
| EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | 15183 | 3.3% | |
| ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO | 7301 | 1.6% | |
| ORGANIZACAO RELIGIOSA | 2908 | 0.6% | |
| SOCIEDADE ANONIMA FECHADA | 2196 | 0.5% | |
| CONDOMINIO EDILICIO | 2084 | 0.5% | |
| ENTIDADE SINDICAL | 1763 | 0.4% | |
| CANDIDATO A CARGO POLITICO ELETIVO | 1617 | 0.3% | |
| Other values (57) | 12565 | 2.7% |
| Max length | 70 |
|---|---|
| Mean length | 24.49725069 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_nivel_atividade
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 2.4% |
| Missing (n) | 11168 |
| MEDIA | |
|---|---|
| ALTA | |
| BAIXA | |
| (Missing) | 11168 |
| Value | Count | Frequency (%) | |
| MEDIA | 217949 | 47.1% | |
| ALTA | 152245 | 32.9% | |
| BAIXA | 76080 | 16.5% | |
| MUITO BAIXA | 4856 | 1.1% | |
| (Missing) | 11168 | 2.4% |
| Max length | 11 |
|---|---|
| Mean length | 4.685386915 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_ramo
Categorical
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| COMERCIO VAREJISTA | |
|---|---|
| SERVICOS DIVERSOS | |
| SERVICOS DE ALOJAMENTO/ALIMENTACAO | 30180 |
| Other values (30) |
| Value | Count | Frequency (%) | |
| COMERCIO VAREJISTA | 172404 | 37.3% | |
| SERVICOS DIVERSOS | 60318 | 13.0% | |
| SERVICOS DE ALOJAMENTO/ALIMENTACAO | 30180 | 6.5% | |
| INDUSTRIA DA CONSTRUCAO | 25363 | 5.5% | |
| COMERCIO E REPARACAO DE VEICULOS | 22356 | 4.8% | |
| SERVICOS ADMINISTRATIVOS | 21326 | 4.6% | |
| BENS DE CONSUMO | 21227 | 4.6% | |
| SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | 17371 | 3.8% | |
| COMERCIO POR ATACADO | 16464 | 3.6% | |
| TRANSPORTE, ARMAZENAGEM E CORREIO | 15485 | 3.3% | |
| Other values (23) | 59804 | 12.9% |
| Max length | 49 |
|---|---|
| Mean length | 22.05983154 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_saude_rescencia
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 3.2% |
| Missing (n) | 14851 |
| ACIMA DE 1 ANO | |
|---|---|
| ATE 1 ANO | 38101 |
| SEM INFORMACAO | 30425 |
| Other values (2) | 25 |
| (Missing) | 14851 |
| Value | Count | Frequency (%) | |
| ACIMA DE 1 ANO | 378896 | 82.0% | |
| ATE 1 ANO | 38101 | 8.2% | |
| SEM INFORMACAO | 30425 | 6.6% | |
| ATE 3 MESES | 13 | < 0.1% | |
| ATE 6 MESES | 12 | < 0.1% | |
| (Missing) | 14851 | 3.2% |
| Max length | 14 |
|---|---|
| Mean length | 13.23438778 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_saude_tributaria
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 3.2% |
| Missing (n) | 14851 |
| VERDE | |
|---|---|
| AZUL | |
| AMARELO | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| VERDE | 145430 | 31.5% | |
| AZUL | 105230 | 22.8% | |
| AMARELO | 91045 | 19.7% | |
| CINZA | 64019 | 13.8% | |
| LARANJA | 36116 | 7.8% | |
| VERMELHO | 5607 | 1.2% | |
| (Missing) | 14851 | 3.2% |
| Max length | 8 |
|---|---|
| Mean length | 5.294638956 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
dt_situacao
Categorical
| Distinct count | 7335 |
|---|---|
| Unique (%) | 1.6% |
| Missing (%) | < 0.1% |
| Missing (n) | 6 |
| 2005-11-03 | 69465 |
|---|---|
| 2006-12-21 | 2207 |
| 2006-12-01 | 2018 |
| Other values (7331) |
| Value | Count | Frequency (%) | |
| 2005-11-03 | 69465 | 15.0% | |
| 2006-12-21 | 2207 | 0.5% | |
| 2006-12-01 | 2018 | 0.4% | |
| 2010-05-15 | 1799 | 0.4% | |
| 2005-09-24 | 1523 | 0.3% | |
| 1998-07-28 | 1490 | 0.3% | |
| 2006-12-02 | 1436 | 0.3% | |
| 2005-08-27 | 1391 | 0.3% | |
| 2004-10-30 | 954 | 0.2% | |
| 2001-07-01 | 892 | 0.2% | |
| Other values (7324) | 379117 | 82.0% |
| Max length | 10 |
|---|---|
| Mean length | 9.99990915 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
empsetorcensitariofaixarendapopulacao
Numeric
| Distinct count | 15420 |
|---|---|
| Unique (%) | 3.3% |
| Missing (%) | 31.1% |
| Missing (n) | 143829 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1308.005725 |
|---|---|
| Minimum | 100 |
| Maximum | 75093.84 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 424.28 |
| Q1 | 673.23 |
| Median | 946.68 |
| Q3 | 1518.08 |
| 95-th percentile | 3516.99 |
| Maximum | 75093.84 |
| Range | 74993.84 |
| Interquartile range | 844.85 |
Descriptive statistics
| Standard deviation | 1161.889222 |
|---|---|
| Coef of variation | 0.8882906242 |
| Kurtosis | 397.288486 |
| Mean | 1308.005725 |
| MAD | 721.2561603 |
| Skewness | 9.232437997 |
| Sum | 416559275.1 |
| Variance | 1349986.563 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 1549.1 | 1995 | 0.4% | |
| 2361.38 | 830 | 0.2% | |
| 1086.05 | 729 | 0.2% | |
| 3940.05 | 536 | 0.1% | |
| 3321.86 | 536 | 0.1% | |
| 2679.5 | 529 | 0.1% | |
| 3071.98 | 479 | 0.1% | |
| 786.74 | 456 | 0.1% | |
| 1910.81 | 447 | 0.1% | |
| 2019.39 | 445 | 0.1% | |
| Other values (15409) | 311487 | 67.4% | |
| (Missing) | 143829 | 31.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 100 | 3 | < 0.1% | |
| 106.67 | 1 | < 0.1% | |
| 107.7 | 1 | < 0.1% | |
| 110.3 | 72 | < 0.1% | |
| 130 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 75093.84 | 7 | < 0.1% | |
| 30861.81 | 22 | < 0.1% | |
| 15137.49 | 3 | < 0.1% | |
| 13793 | 22 | < 0.1% | |
| 12512.93 | 149 | < 0.1% |
fl_antt
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| 0 | |
|---|---|
| 1 | 3276 |
| (Missing) | 1927 |
| Value | Count | Frequency (%) | |
| 0 | 457095 | 98.9% | |
| 1 | 3276 | 0.7% | |
| (Missing) | 1927 | 0.4% |
fl_email
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 256228 | 55.4% | |
| 1 | 206070 | 44.6% |
fl_ltda
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1242 |
| Value | Count | Frequency (%) | |
| 0 | 461056 | 99.7% | |
| 1 | 1242 | 0.3% |
fl_matriz
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 | 29066 |
| Value | Count | Frequency (%) | |
| 1 | 433232 | 93.7% | |
| 0 | 29066 | 6.3% |
fl_me
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1215 |
| Value | Count | Frequency (%) | |
| 0 | 461083 | 99.7% | |
| 1 | 1215 | 0.3% |
fl_mei
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 311398 | 67.4% | |
| 1 | 150900 | 32.6% |
fl_optante_simei
Highly correlated
This variable is highly correlated with fl_mei and should be ignored for analysis
| Correlation | 0.9579210437 |
|---|
fl_optante_simples
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 17.9% |
| Missing (n) | 82713 |
| 1 | |
|---|---|
| 0 | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 199617 | 43.2% | |
| 0 | 179968 | 38.9% | |
| (Missing) | 82713 | 17.9% |
fl_passivel_iss
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 1927 |
| Value | Count | Frequency (%) | |
| 1 | 264741 | 57.3% | |
| 0 | 195630 | 42.3% | |
| (Missing) | 1927 | 0.4% |
fl_rm
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 236779 | 51.2% | |
| 1 | 225519 | 48.8% |
fl_sa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 8432 |
| Value | Count | Frequency (%) | |
| 0 | 453866 | 98.2% | |
| 1 | 8432 | 1.8% |
fl_simples_irregular
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| 0 | |
|---|---|
| 1 | 341 |
| (Missing) | 1927 |
| Value | Count | Frequency (%) | |
| 0 | 460030 | 99.5% | |
| 1 | 341 | 0.1% | |
| (Missing) | 1927 | 0.4% |
fl_spa
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| 0 | |
|---|---|
| 1 | 280 |
| (Missing) | 1927 |
| Value | Count | Frequency (%) | |
| 0 | 460091 | 99.5% | |
| 1 | 280 | 0.1% | |
| (Missing) | 1927 | 0.4% |
fl_st_especial
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 68 |
| Value | Count | Frequency (%) | |
| 0 | 462230 | > 99.9% | |
| 1 | 68 | < 0.1% |
fl_telefone
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 335468 | 72.6% | |
| 0 | 126830 | 27.4% |
fl_veiculo
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| 0 | |
|---|---|
| 1 | 30684 |
| (Missing) | 1927 |
| Value | Count | Frequency (%) | |
| 0 | 429687 | 92.9% | |
| 1 | 30684 | 6.6% | |
| (Missing) | 1927 | 0.4% |
id
Categorical, Unique
| First 5 values |
|---|
| 000001857eec66f7d67ea918825c9980eebff5c10b36f3... |
| 0000133f443484b40bc632e3b8595c8348441b3899973f... |
| 000047a124312a6e977ac8e37c677ae4eed7614d945996... |
| 000061121bf1a98d79c02f156af0cadec80ea1c68236e6... |
| 00009a58c6d16b1439d1918b27734c78283a7264e0ac1e... |
| Last 5 values |
|---|
| ffff6c0b13631b6bf0dc823675f8f54bf66552b8c87521... |
| ffff8882a623edc8a4b322217921aad8a3e84efacdaea1... |
| ffff989f6f3a687bcf883db3de06772544b625dcc29635... |
| ffff996a58acd0fc5e95b95edc812827b37fff57c3c239... |
| ffffd4fc4571772f61964cafe6c28a8d1fb8cec9103093... |
First 5 values
| Value | Count | Frequency (%) | |
| 000001857eec66f7d67ea918825c9980eebff5c10b36f3cbcf8b977dae2673f3 | 1 | < 0.1% | |
| 0000133f443484b40bc632e3b8595c8348441b3899973f25a5375e915f84ef88 | 1 | < 0.1% | |
| 000047a124312a6e977ac8e37c677ae4eed7614d9459968a48875a030c2bb31c | 1 | < 0.1% | |
| 000061121bf1a98d79c02f156af0cadec80ea1c68236e69c8a36d0b087878a78 | 1 | < 0.1% | |
| 00009a58c6d16b1439d1918b27734c78283a7264e0ac1ed169baf5304b72f538 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| ffffd4fc4571772f61964cafe6c28a8d1fb8cec91030934be200aaec2d902161 | 1 | < 0.1% | |
| ffff996a58acd0fc5e95b95edc812827b37fff57c3c239f037cedf6cfb574dfb | 1 | < 0.1% | |
| ffff989f6f3a687bcf883db3de06772544b625dcc29635ddaf631d7ba3dc6584 | 1 | < 0.1% | |
| ffff8882a623edc8a4b322217921aad8a3e84efacdaea101cfd23bceef91fb5a | 1 | < 0.1% | |
| ffff6c0b13631b6bf0dc823675f8f54bf66552b8c87521bd419642465b05e304 | 1 | < 0.1% |
idade_emp_cat
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 a 5 | |
|---|---|
| 5 a 10 | |
| > 20 | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| 1 a 5 | 138580 | 30.0% | |
| 5 a 10 | 116100 | 25.1% | |
| > 20 | 75572 | 16.3% | |
| 10 a 15 | 49205 | 10.6% | |
| <= 1 | 46794 | 10.1% | |
| 15 a 20 | 36047 | 7.8% |
| Max length | 7 |
|---|---|
| Mean length | 5.355264353 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
idade_empresa_anos
Numeric
| Distinct count | 14198 |
|---|---|
| Unique (%) | 3.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.948676561 |
|---|---|
| Minimum | 0.01643835616 |
| Maximum | 106.4328767 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.01643835616 |
|---|---|
| 5-th percentile | 0.4575342466 |
| Q1 | 2.756164384 |
| Median | 6.704109589 |
| Q3 | 14.46575342 |
| 95-th percentile | 30.17808219 |
| Maximum | 106.4328767 |
| Range | 106.4164384 |
| Interquartile range | 11.70958904 |
Descriptive statistics
| Standard deviation | 9.615664247 |
|---|---|
| Coef of variation | 0.9665269735 |
| Kurtosis | 1.52217534 |
| Mean | 9.948676561 |
| MAD | 7.553130844 |
| Skewness | 1.376723032 |
| Sum | 4599253.277 |
| Variance | 92.46099891 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 0.2054794521 | 595 | 0.1% | |
| 0.2082191781 | 571 | 0.1% | |
| 0.202739726 | 470 | 0.1% | |
| 0.2164383562 | 322 | 0.1% | |
| 7.331506849 | 281 | 0.1% | |
| 0.2219178082 | 276 | 0.1% | |
| 6.317808219 | 271 | 0.1% | |
| 3.536986301 | 260 | 0.1% | |
| 3.534246575 | 257 | 0.1% | |
| 6.315068493 | 256 | 0.1% | |
| Other values (14188) | 458739 | 99.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.01643835616 | 1 | < 0.1% | |
| 0.02739726027 | 24 | < 0.1% | |
| 0.0301369863 | 179 | < 0.1% | |
| 0.03287671233 | 188 | < 0.1% | |
| 0.03561643836 | 193 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 106.4328767 | 1 | < 0.1% | |
| 89.44383562 | 1 | < 0.1% | |
| 80.63835616 | 1 | < 0.1% | |
| 77.52876712 | 1 | < 0.1% | |
| 75.05479452 | 1 | < 0.1% |
idade_maxima_socios
Numeric
| Distinct count | 119 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 32.8% |
| Missing (n) | 151602 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 44.3441306 |
|---|---|
| Minimum | -2 |
| Maximum | 127 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -2 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 34 |
| Median | 43 |
| Q3 | 54 |
| 95-th percentile | 69 |
| Maximum | 127 |
| Range | 129 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 13.93038532 |
|---|---|
| Coef of variation | 0.3141427091 |
| Kurtosis | -0.0009405849143 |
| Mean | 44.3441306 |
| MAD | 11.33842405 |
| Skewness | 0.5390117117 |
| Sum | 13777544 |
| Variance | 194.0556351 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 37 | 8925 | 1.9% | |
| 36 | 8906 | 1.9% | |
| 39 | 8721 | 1.9% | |
| 38 | 8699 | 1.9% | |
| 40 | 8686 | 1.9% | |
| 41 | 8591 | 1.9% | |
| 35 | 8500 | 1.8% | |
| 33 | 8306 | 1.8% | |
| 34 | 8095 | 1.8% | |
| 42 | 8089 | 1.7% | |
| Other values (108) | 225178 | 48.7% | |
| (Missing) | 151602 | 32.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 3 | < 0.1% | |
| 6 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 127 | 1 | < 0.1% | |
| 125 | 1 | < 0.1% | |
| 123 | 1 | < 0.1% | |
| 121 | 1 | < 0.1% | |
| 120 | 1 | < 0.1% |
idade_media_socios
Highly correlated
This variable is highly correlated with idade_maxima_socios and should be ignored for analysis
| Correlation | 0.9568741341 |
|---|
idade_minima_socios
Highly correlated
This variable is highly correlated with idade_media_socios and should be ignored for analysis
| Correlation | 0.9533591208 |
|---|
natureza_juridica_macro
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| OUTROS | |
|---|---|
| ENTIDADES EMPRESARIAIS | |
| ENTIDADES SEM FINS LUCRATIVOS | 37089 |
| Other values (4) | 5757 |
| Value | Count | Frequency (%) | |
| OUTROS | 320211 | 69.3% | |
| ENTIDADES EMPRESARIAIS | 99241 | 21.5% | |
| ENTIDADES SEM FINS LUCRATIVOS | 37089 | 8.0% | |
| ADMINISTRACAO PUBLICA | 2912 | 0.6% | |
| CARGO POLITICO | 1617 | 0.3% | |
| PESSOAS FISICAS | 1225 | 0.3% | |
| INSTITUICOES EXTRATERRITORIAIS | 3 | < 0.1% |
| Max length | 30 |
|---|---|
| Mean length | 11.42640461 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_divisao
Categorical
| Distinct count | 88 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| COMERCIO VAREJISTA | |
|---|---|
| ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS | 37984 |
| ALIMENTACAO | 27540 |
| Other values (84) |
| Value | Count | Frequency (%) | |
| COMERCIO VAREJISTA | 172404 | 37.3% | |
| ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS | 37984 | 8.2% | |
| ALIMENTACAO | 27540 | 6.0% | |
| COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 22356 | 4.8% | |
| COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS | 16464 | 3.6% | |
| OUTRAS ATIVIDADES DE SERVICOS PESSOAIS | 15875 | 3.4% | |
| SERVICOS ESPECIALIZADOS PARA CONSTRUCAO | 14291 | 3.1% | |
| TRANSPORTE TERRESTRE | 11439 | 2.5% | |
| EDUCACAO | 11311 | 2.4% | |
| SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS | 9726 | 2.1% | |
| Other values (77) | 120981 | 26.2% |
| Max length | 120 |
|---|---|
| Mean length | 32.89757905 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_meso_regiao
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 12.7% |
| Missing (n) | 58698 |
| CENTRO AMAZONENSE | |
|---|---|
| NORTE MARANHENSE | |
| LESTE POTIGUAR | |
| Other values (16) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| CENTRO AMAZONENSE | 71469 | 15.5% | |
| NORTE MARANHENSE | 61331 | 13.3% | |
| LESTE POTIGUAR | 58762 | 12.7% | |
| CENTRO NORTE PIAUIENSE | 42244 | 9.1% | |
| OESTE MARANHENSE | 26796 | 5.8% | |
| OESTE POTIGUAR | 20860 | 4.5% | |
| LESTE MARANHENSE | 17651 | 3.8% | |
| VALE DO ACRE | 16539 | 3.6% | |
| CENTRO MARANHENSE | 13755 | 3.0% | |
| SUDOESTE PIAUIENSE | 12180 | 2.6% | |
| Other values (9) | 62013 | 13.4% | |
| (Missing) | 58698 | 12.7% |
| Max length | 22 |
|---|---|
| Mean length | 14.58877174 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_micro_regiao
Categorical
| Distinct count | 74 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 12.7% |
| Missing (n) | 58698 |
| MANAUS | |
|---|---|
| NATAL | 46745 |
| AGLOMERACAO URBANA DE SAO LUIS | 45875 |
| Other values (70) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| MANAUS | 60008 | 13.0% | |
| NATAL | 46745 | 10.1% | |
| AGLOMERACAO URBANA DE SAO LUIS | 45875 | 9.9% | |
| TERESINA | 33887 | 7.3% | |
| IMPERATRIZ | 15912 | 3.4% | |
| RIO BRANCO | 14064 | 3.0% | |
| MOSSORO | 10713 | 2.3% | |
| PINDARE | 8167 | 1.8% | |
| MACAIBA | 7318 | 1.6% | |
| LITORAL PIAUIENSE | 6816 | 1.5% | |
| Other values (63) | 154095 | 33.3% | |
| (Missing) | 58698 | 12.7% |
| Max length | 33 |
|---|---|
| Mean length | 11.08048056 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_segmento
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | |
|---|---|
| OUTRAS ATIVIDADES DE SERVICOS | |
| INDUSTRIAS DE TRANSFORMACAO | 31968 |
| Other values (18) |
| Value | Count | Frequency (%) | |
| COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 211224 | 45.7% | |
| OUTRAS ATIVIDADES DE SERVICOS | 59561 | 12.9% | |
| INDUSTRIAS DE TRANSFORMACAO | 31968 | 6.9% | |
| ALOJAMENTO E ALIMENTACAO | 30180 | 6.5% | |
| CONSTRUCAO | 25363 | 5.5% | |
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 21326 | 4.6% | |
| ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 17371 | 3.8% | |
| TRANSPORTE ARMAZENAGEM E CORREIO | 15485 | 3.3% | |
| EDUCACAO | 11311 | 2.4% | |
| SAUDE HUMANA E SERVICOS SOCIAIS | 10139 | 2.2% | |
| Other values (11) | 26443 | 5.7% |
| Max length | 65 |
|---|---|
| Mean length | 42.52199447 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nu_meses_rescencia
Numeric
| Distinct count | 52 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 9.8% |
| Missing (n) | 45276 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 25.00724662 |
|---|---|
| Minimum | 0 |
| Maximum | 66 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 22 |
| Median | 23 |
| Q3 | 25 |
| 95-th percentile | 48 |
| Maximum | 66 |
| Range | 66 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 9.679799286 |
|---|---|
| Coef of variation | 0.3870797707 |
| Kurtosis | 1.945603876 |
| Mean | 25.00724662 |
| MAD | 5.88354324 |
| Skewness | 1.261726999 |
| Sum | 10428572 |
| Variance | 93.69851423 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 23 | 108609 | 23.5% | |
| 22 | 89143 | 19.3% | |
| 24 | 44574 | 9.6% | |
| 48 | 26480 | 5.7% | |
| 25 | 25087 | 5.4% | |
| 26 | 24218 | 5.2% | |
| 27 | 18888 | 4.1% | |
| 21 | 12154 | 2.6% | |
| 7 | 10016 | 2.2% | |
| 47 | 9637 | 2.1% | |
| Other values (41) | 48216 | 10.4% | |
| (Missing) | 45276 | 9.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4 | < 0.1% | |
| 1 | 4 | < 0.1% | |
| 2 | 5 | < 0.1% | |
| 5 | 8 | < 0.1% | |
| 6 | 4 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 66 | 41 | < 0.1% | |
| 65 | 33 | < 0.1% | |
| 64 | 4 | < 0.1% | |
| 54 | 1560 | 0.3% | |
| 53 | 51 | < 0.1% |
qt_filiais
Numeric
| Distinct count | 304 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 28.73704407 |
|---|---|
| Minimum | 0 |
| Maximum | 9647 |
| Zeros (%) | 90.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 9647 |
| Range | 9647 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 468.6260942 |
|---|---|
| Coef of variation | 16.30738684 |
| Kurtosis | 356.9251027 |
| Mean | 28.73704407 |
| MAD | 56.06139032 |
| Skewness | 18.6663858 |
| Sum | 13285078 |
| Variance | 219610.4161 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 0 | 418043 | 90.4% | |
| 1 | 19561 | 4.2% | |
| 2 | 5943 | 1.3% | |
| 3 | 2884 | 0.6% | |
| 4 | 1772 | 0.4% | |
| 5 | 1161 | 0.3% | |
| 6 | 818 | 0.2% | |
| 7 | 637 | 0.1% | |
| 8 | 544 | 0.1% | |
| 9 | 485 | 0.1% | |
| Other values (294) | 10450 | 2.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 418043 | 90.4% | |
| 1 | 19561 | 4.2% | |
| 2 | 5943 | 1.3% | |
| 3 | 2884 | 0.6% | |
| 4 | 1772 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9647 | 265 | 0.1% | |
| 9411 | 281 | 0.1% | |
| 9270 | 373 | 0.1% | |
| 7687 | 191 | < 0.1% | |
| 5491 | 106 | < 0.1% |
qt_socios
Numeric
| Distinct count | 63 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 24.9% |
| Missing (n) | 115091 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.496326399 |
|---|---|
| Minimum | 1 |
| Maximum | 246 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 246 |
| Range | 245 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 3.276626415 |
|---|---|
| Coef of variation | 2.18978053 |
| Kurtosis | 923.2237301 |
| Mean | 1.496326399 |
| MAD | 0.7386222867 |
| Skewness | 27.25083606 |
| Sum | 519535 |
| Variance | 10.73628066 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 1 | 258353 | 55.9% | |
| 2 | 71030 | 15.4% | |
| 3 | 8902 | 1.9% | |
| 4 | 3214 | 0.7% | |
| 5 | 1612 | 0.3% | |
| 6 | 998 | 0.2% | |
| 8 | 749 | 0.2% | |
| 7 | 557 | 0.1% | |
| 9 | 300 | 0.1% | |
| 96 | 265 | 0.1% | |
| Other values (52) | 1227 | 0.3% | |
| (Missing) | 115091 | 24.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 258353 | 55.9% | |
| 2 | 71030 | 15.4% | |
| 3 | 8902 | 1.9% | |
| 4 | 3214 | 0.7% | |
| 5 | 1612 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 246 | 1 | < 0.1% | |
| 238 | 1 | < 0.1% | |
| 199 | 1 | < 0.1% | |
| 168 | 1 | < 0.1% | |
| 165 | 1 | < 0.1% |
qt_socios_feminino
Numeric
| Distinct count | 34 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 68.6% |
| Missing (n) | 317269 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.107116508 |
|---|---|
| Minimum | 1 |
| Maximum | 140 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 140 |
| Range | 139 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.8401936523 |
|---|---|
| Coef of variation | 0.7589026507 |
| Kurtosis | 9249.637522 |
| Mean | 1.107116508 |
| MAD | 0.1980018315 |
| Skewness | 76.48075241 |
| Sum | 160564 |
| Variance | 0.7059253734 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 1 | 134041 | 29.0% | |
| 2 | 9084 | 2.0% | |
| 3 | 1247 | 0.3% | |
| 4 | 324 | 0.1% | |
| 5 | 133 | < 0.1% | |
| 6 | 59 | < 0.1% | |
| 7 | 30 | < 0.1% | |
| 15 | 28 | < 0.1% | |
| 9 | 23 | < 0.1% | |
| 8 | 16 | < 0.1% | |
| Other values (23) | 44 | < 0.1% | |
| (Missing) | 317269 | 68.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 134041 | 29.0% | |
| 2 | 9084 | 2.0% | |
| 3 | 1247 | 0.3% | |
| 4 | 324 | 0.1% | |
| 5 | 133 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 140 | 1 | < 0.1% | |
| 95 | 1 | < 0.1% | |
| 93 | 1 | < 0.1% | |
| 88 | 1 | < 0.1% | |
| 74 | 1 | < 0.1% |
qt_socios_masculino
Highly correlated
This variable is highly correlated with qt_socios and should be ignored for analysis
| Correlation | 0.9632367436 |
|---|
qt_socios_pf
Highly correlated
This variable is highly correlated with qt_socios_masculino and should be ignored for analysis
| Correlation | 0.9652540624 |
|---|
qt_socios_pj
Numeric
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 24.9% |
| Missing (n) | 115091 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01964534125 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros (%) | 74.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1951660243 |
|---|---|
| Coef of variation | 9.934468524 |
| Kurtosis | 362.7623512 |
| Mean | 0.01964534125 |
| MAD | 0.0387764738 |
| Skewness | 14.78811156 |
| Sum | 6821 |
| Variance | 0.03808977704 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 0 | 342663 | 74.1% | |
| 1 | 2783 | 0.6% | |
| 2 | 1459 | 0.3% | |
| 3 | 193 | < 0.1% | |
| 4 | 70 | < 0.1% | |
| 5 | 14 | < 0.1% | |
| 7 | 9 | < 0.1% | |
| 6 | 6 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| Other values (2) | 2 | < 0.1% | |
| (Missing) | 115091 | 24.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 342663 | 74.1% | |
| 1 | 2783 | 0.6% | |
| 2 | 1459 | 0.3% | |
| 3 | 193 | < 0.1% | |
| 4 | 70 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 7 | 9 | < 0.1% |
qt_socios_st_regular
Highly correlated
This variable is highly correlated with qt_socios_pf and should be ignored for analysis
| Correlation | 0.9883617721 |
|---|
setor
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| COMERCIO | |
|---|---|
| SERVIÇO | |
| INDUSTRIA | 30893 |
| Other values (2) | 28610 |
| Value | Count | Frequency (%) | |
| COMERCIO | 211224 | 45.7% | |
| SERVIÇO | 189644 | 41.0% | |
| INDUSTRIA | 30893 | 6.7% | |
| CONSTRUÇÃO CIVIL | 25363 | 5.5% | |
| AGROPECUARIA | 3247 | 0.7% | |
| (Missing) | 1927 | 0.4% |
| Max length | 16 |
|---|---|
| Mean length | 8.102760557 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
sg_uf
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MA | |
|---|---|
| RN | |
| AM | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| MA | 127654 | 27.6% | |
| RN | 98837 | 21.4% | |
| AM | 82114 | 17.8% | |
| PI | 76686 | 16.6% | |
| RO | 56469 | 12.2% | |
| AC | 20538 | 4.4% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sg_uf_matriz
Categorical
| Distinct count | 28 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1939 |
| MA | |
|---|---|
| RN | |
| AM | |
| Other values (24) |
| Value | Count | Frequency (%) | |
| MA | 124823 | 27.0% | |
| RN | 96743 | 20.9% | |
| AM | 80032 | 17.3% | |
| PI | 75201 | 16.3% | |
| RO | 54876 | 11.9% | |
| AC | 20028 | 4.3% | |
| SP | 2845 | 0.6% | |
| DF | 1225 | 0.3% | |
| CE | 927 | 0.2% | |
| RJ | 669 | 0.1% | |
| Other values (17) | 2990 | 0.6% | |
| (Missing) | 1939 | 0.4% |
| Max length | 3 |
|---|---|
| Mean length | 2.004194264 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
vl_faturamento_estimado_aux
Numeric
| Distinct count | 1921 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 6.0% |
| Missing (n) | 27513 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 802091.1378 |
|---|---|
| Minimum | 0 |
| Maximum | 1.4546625e+10 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50000 |
| Q1 | 164851.2 |
| Median | 210000 |
| Q3 | 210000 |
| 95-th percentile | 989107.2 |
| Maximum | 1.4546625e+10 |
| Range | 1.4546625e+10 |
| Interquartile range | 45148.8 |
Descriptive statistics
| Standard deviation | 30999788.42 |
|---|---|
| Coef of variation | 38.6487108 |
| Kurtosis | 137216.1313 |
| Mean | 802091.1378 |
| MAD | 1119630.467 |
| Skewness | 329.062977 |
| Sum | 3.487371953e+11 |
| Variance | 9.609868822e+14 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 210000 | 249868 | 54.0% | |
| 50000 | 94137 | 20.4% | |
| 930000 | 16075 | 3.5% | |
| 185457.6 | 8252 | 1.8% | |
| 370915.2 | 6489 | 1.4% | |
| 123638.4 | 6357 | 1.4% | |
| 247276.8 | 3920 | 0.8% | |
| 556372.8 | 2901 | 0.6% | |
| 741830.4 | 2853 | 0.6% | |
| 61819.2 | 2162 | 0.5% | |
| Other values (1910) | 41771 | 9.0% | |
| (Missing) | 27513 | 6.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1173 | 0.3% | |
| 41047.03 | 1 | < 0.1% | |
| 41212.8 | 1923 | 0.4% | |
| 50000 | 94137 | 20.4% | |
| 51516 | 335 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.4546625e+10 | 1 | < 0.1% | |
| 9961906000 | 1 | < 0.1% | |
| 3490930200 | 1 | < 0.1% | |
| 3220831700 | 1 | < 0.1% | |
| 2669847000 | 1 | < 0.1% |
vl_faturamento_estimado_grupo_aux
Numeric
| Distinct count | 6795 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 6.0% |
| Missing (n) | 27513 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 336720529.8 |
|---|---|
| Minimum | 41047.03 |
| Maximum | 2.227618e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 41047.03 |
|---|---|
| 5-th percentile | 50000 |
| Q1 | 185457.6 |
| Median | 210000 |
| Q3 | 210000 |
| 95-th percentile | 2843683.2 |
| Maximum | 2.227618e+11 |
| Range | 2.22761759e+11 |
| Interquartile range | 24542.4 |
Descriptive statistics
| Standard deviation | 7114614457 |
|---|---|
| Coef of variation | 21.12913775 |
| Kurtosis | 756.5828773 |
| Mean | 336720529.8 |
| MAD | 662945084.1 |
| Skewness | 26.79710656 |
| Sum | 1.464010356e+14 |
| Variance | 5.061773887e+19 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 210000 | 230845 | 49.9% | |
| 50000 | 94137 | 20.4% | |
| 930000 | 12789 | 2.8% | |
| 185457.6 | 7149 | 1.5% | |
| 420000 | 6916 | 1.5% | |
| 123638.4 | 5696 | 1.2% | |
| 370915.2 | 5573 | 1.2% | |
| 247276.8 | 3415 | 0.7% | |
| 741830.4 | 2396 | 0.5% | |
| 556372.8 | 2391 | 0.5% | |
| Other values (6784) | 63478 | 13.7% | |
| (Missing) | 27513 | 6.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 41047.03 | 1 | < 0.1% | |
| 41212.8 | 1774 | 0.4% | |
| 50000 | 94137 | 20.4% | |
| 51516 | 308 | 0.1% | |
| 61819.2 | 1898 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.227618e+11 | 191 | < 0.1% | |
| 1.8943014e+11 | 265 | 0.1% | |
| 1.8120853e+11 | 26 | < 0.1% | |
| 1.2398112e+11 | 9 | < 0.1% | |
| 1.009873e+11 | 15 | < 0.1% |
vl_total_veiculos_leves_grupo
Numeric
| Distinct count | 311 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 48.6991774 |
|---|---|
| Minimum | 0 |
| Maximum | 122090 |
| Zeros (%) | 91.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 122090 |
| Range | 122090 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1206.696804 |
|---|---|
| Coef of variation | 24.77858699 |
| Kurtosis | 1614.685275 |
| Mean | 48.6991774 |
| MAD | 95.963728 |
| Skewness | 34.48790893 |
| Sum | 22419689 |
| Variance | 1456117.176 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 0 | 424180 | 91.8% | |
| 1 | 15738 | 3.4% | |
| 2 | 5232 | 1.1% | |
| 3 | 2610 | 0.6% | |
| 4 | 1569 | 0.3% | |
| 5 | 1099 | 0.2% | |
| 6 | 781 | 0.2% | |
| 7 | 618 | 0.1% | |
| 8 | 512 | 0.1% | |
| 10 | 408 | 0.1% | |
| Other values (300) | 7624 | 1.6% | |
| (Missing) | 1927 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 424180 | 91.8% | |
| 1 | 15738 | 3.4% | |
| 2 | 5232 | 1.1% | |
| 3 | 2610 | 0.6% | |
| 4 | 1569 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 122090 | 2 | < 0.1% | |
| 105312 | 2 | < 0.1% | |
| 96763 | 2 | < 0.1% | |
| 57941 | 2 | < 0.1% | |
| 44250 | 1 | < 0.1% |
vl_total_veiculos_pesados_grupo
Numeric
| Distinct count | 297 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 1927 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.591800961 |
|---|---|
| Minimum | 0 |
| Maximum | 9782 |
| Zeros (%) | 95.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9782 |
| Range | 9782 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 72.60035227 |
|---|---|
| Coef of variation | 20.21279939 |
| Kurtosis | 1491.122182 |
| Mean | 3.591800961 |
| MAD | 6.98457279 |
| Skewness | 31.26208196 |
| Sum | 1653561 |
| Variance | 5270.81115 |
| Memory size | 3.5 MiB |
| Value | Count | Frequency (%) | |
| 0 | 441360 | 95.5% | |
| 1 | 6785 | 1.5% | |
| 2 | 2585 | 0.6% | |
| 3 | 1301 | 0.3% | |
| 4 | 827 | 0.2% | |
| 5 | 653 | 0.1% | |
| 7 | 532 | 0.1% | |
| 6 | 487 | 0.1% | |
| 1177 | 373 | 0.1% | |
| 95 | 283 | 0.1% | |
| Other values (286) | 5185 | 1.1% | |
| (Missing) | 1927 | 0.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 441360 | 95.5% | |
| 1 | 6785 | 1.5% | |
| 2 | 2585 | 0.6% | |
| 3 | 1301 | 0.3% | |
| 4 | 827 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9782 | 1 | < 0.1% | |
| 3674 | 2 | < 0.1% | |
| 3484 | 1 | < 0.1% | |
| 2710 | 2 | < 0.1% | |
| 2693 | 5 | < 0.1% |
First rows
| de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | fl_antt | fl_email | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | id | idade_emp_cat | idade_empresa_anos | idade_maxima_socios | idade_media_socios | idade_minima_socios | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | qt_filiais | qt_socios | qt_socios_feminino | qt_socios_masculino | qt_socios_pf | qt_socios_pj | qt_socios_st_regular | setor | sg_uf | sg_uf_matriz | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DE R$ 1.500.000,01 A R$ 4.800.000,00 | DE R$ 1.500.000,01 A R$ 4.800.000,00 | SOCIEDADE EMPRESARIA LIMITADA | ALTA | INDUSTRIA DA CONSTRUCAO | ACIMA DE 1 ANO | VERDE | 2005-03-25 | NaN | 0.0 | 1 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | a6984c3ae395090e3bee8ad63c3758b110de096d5d8195... | 10 a 15 | 14.457534 | 47.0 | 44.0 | 41.0 | ENTIDADES EMPRESARIAIS | CONSTRUCAO DE EDIFICIOS | LESTE POTIGUAR | NATAL | CONSTRUCAO | 23.0 | 0 | 2.0 | NaN | 2.0 | 2.0 | 0.0 | 2.0 | CONSTRUÇÃO CIVIL | RN | RN | 3132172.8 | 3132172.8 | 0.0 | 0.0 |
| 1 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | BAIXA | SERVICOS DE ALOJAMENTO/ALIMENTACAO | ATE 1 ANO | CINZA | 2017-05-12 | 468.93 | 0.0 | 1 | 0 | 1 | 0 | 1 | NaN | NaN | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4... | 1 a 5 | 1.463014 | 27.0 | 27.0 | 27.0 | OUTROS | ALIMENTACAO | CENTRO NORTE PIAUIENSE | TERESINA | ALOJAMENTO E ALIMENTACAO | 9.0 | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | 1.0 | SERVIÇO | PI | PI | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 2 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | TRANSPORTE, ARMAZENAGEM E CORREIO | ACIMA DE 1 ANO | AMARELO | 2011-09-26 | 713.50 | 0.0 | 0 | 0 | 1 | 0 | 1 | 1.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02... | 5 a 10 | 7.093151 | 32.0 | 32.0 | 32.0 | OUTROS | TRANSPORTE TERRESTRE | CENTRO AMAZONENSE | MANAUS | TRANSPORTE ARMAZENAGEM E CORREIO | 26.0 | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | NaN | SERVIÇO | AM | AM | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 3 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | SERVICOS DIVERSOS | ACIMA DE 1 ANO | AMARELO | 2012-04-25 | 475.73 | 0.0 | 1 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 3348900fe63216a439d2e5238c79ddd46ede454df7b9d8... | 5 a 10 | 6.512329 | 36.0 | 36.0 | 36.0 | OUTROS | REPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO... | CENTRO AMAZONENSE | MANAUS | OUTRAS ATIVIDADES DE SERVICOS | 26.0 | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | 1.0 | SERVIÇO | AM | AM | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 4 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2015-08-17 | 2874.04 | 0.0 | 1 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4... | 1 a 5 | 3.200000 | NaN | NaN | NaN | OUTROS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ... | LESTE POTIGUAR | NATAL | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 27.0 | 0 | 1.0 | NaN | NaN | 1.0 | 0.0 | NaN | SERVIÇO | RN | RN | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 5 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | SOCIEDADE EMPRESARIA LIMITADA | ALTA | QUIMICA-PETROQUIMICA | ACIMA DE 1 ANO | LARANJA | 2005-11-03 | NaN | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6... | > 20 | 38.079452 | NaN | NaN | NaN | ENTIDADES EMPRESARIAIS | FABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOS | OESTE POTIGUAR | PAU DOS FERROS | INDUSTRIAS DE TRANSFORMACAO | 48.0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | INDUSTRIA | RN | RN | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 6 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | TRANSPORTE, ARMAZENAGEM E CORREIO | ACIMA DE 1 ANO | AMARELO | 2011-07-21 | NaN | 0.0 | 1 | 0 | 1 | 0 | 1 | 1.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 8bf37c178778e537b108e58bf20552abe10c3a7fae129b... | 5 a 10 | 7.276712 | 63.0 | 63.0 | 63.0 | OUTROS | TRANSPORTE TERRESTRE | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | TRANSPORTE ARMAZENAGEM E CORREIO | 23.0 | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | 1.0 | SERVIÇO | MA | MA | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 7 | NaN | NaN | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS ADMINISTRATIVOS | NaN | NaN | 2018-10-09 | NaN | 0.0 | 1 | 0 | 1 | 0 | 1 | NaN | NaN | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d... | <= 1 | 0.052055 | 40.0 | 40.0 | 40.0 | OUTROS | AGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE... | LESTE POTIGUAR | NATAL | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME... | NaN | 0 | 1.0 | 1.0 | NaN | 1.0 | 0.0 | 1.0 | SERVIÇO | RN | RN | NaN | NaN | 0.0 | 0.0 |
| 8 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | COOPERATIVA | ALTA | BENS DE CONSUMO | ACIMA DE 1 ANO | AZUL | 2006-07-27 | 247.88 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 1.0 | 0 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 6c45aabb849a760a3a7107c7a61262642f683feb8912a4... | 10 a 15 | 12.263014 | 36.0 | 36.0 | 36.0 | ENTIDADES EMPRESARIAIS | FABRICACAO DE PRODUTOS DIVERSOS | CENTRO AMAZONENSE | PARINTINS | INDUSTRIAS DE TRANSFORMACAO | 24.0 | 0 | 2.0 | NaN | 1.0 | 2.0 | 0.0 | 1.0 | INDUSTRIA | AM | AM | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 9 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 360.000,01 A R$ 1.500.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | VERMELHO | 2004-10-30 | 1042.85 | 0.0 | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926... | 15 a 20 | 17.942466 | 52.0 | 52.0 | 52.0 | OUTROS | COMERCIO VAREJISTA | OESTE POTIGUAR | MOSSORO | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 54.0 | 3 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | NaN | COMERCIO | RN | RN | 210000.0 | 840000.0 | 0.0 | 0.0 |
Last rows
| de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | fl_antt | fl_email | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | id | idade_emp_cat | idade_empresa_anos | idade_maxima_socios | idade_media_socios | idade_minima_socios | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | qt_filiais | qt_socios | qt_socios_feminino | qt_socios_masculino | qt_socios_pf | qt_socios_pj | qt_socios_st_regular | setor | sg_uf | sg_uf_matriz | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 462288 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MEDIA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | AMARELO | 2005-11-03 | 1135.64 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 0.0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 25fc6c2f86ea82180b19935893969ca5943af053cf4fa6... | 10 a 15 | 14.586301 | NaN | NaN | NaN | OUTROS | COMERCIO VAREJISTA | SUDOESTE AMAZONENSE | JURUA | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 22.0 | 0 | 1.0 | NaN | NaN | 1.0 | 0.0 | NaN | COMERCIO | AM | AM | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 462289 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | BAIXA | TEXTEIS | SEM INFORMACAO | CINZA | 2018-02-19 | 1387.18 | 0.0 | 1 | 0 | 1 | 0 | 1 | NaN | NaN | 0.0 | 0 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 7217389b17042e97dd2b35899f375aabd40901c90f26b4... | <= 1 | 0.687671 | 22.0 | 22.000000 | 22.0 | OUTROS | FABRICACAO DE PRODUTOS TEXTEIS | NaN | NaN | INDUSTRIAS DE TRANSFORMACAO | NaN | 0 | 1.0 | 1.0 | NaN | 1.0 | 0.0 | 1.0 | INDUSTRIA | RO | RO | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 462290 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | SOCIEDADE EMPRESARIA LIMITADA | BAIXA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | AZUL | 2009-08-04 | NaN | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 6d1d4e188e3314878b59649c4f840e0ca141a3c03d5bfc... | 5 a 10 | 9.238356 | 27.0 | 27.000000 | 27.0 | ENTIDADES EMPRESARIAIS | SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO... | OESTE MARANHENSE | IMPERATRIZ | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME... | 21.0 | 0 | 2.0 | 1.0 | NaN | 2.0 | 0.0 | 1.0 | SERVIÇO | MA | MA | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 462291 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | ALTA | SERVICOS DIVERSOS | ACIMA DE 1 ANO | AZUL | 2006-02-07 | 6022.81 | 0.0 | 1 | 0 | 1 | 0 | 0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 0 | 1.0 | 916d935f687e32f7c3efb21e982d908074d74eecf7ef4a... | 10 a 15 | 12.728767 | 44.0 | 44.000000 | 44.0 | OUTROS | OUTRAS ATIVIDADES DE SERVICOS PESSOAIS | CENTRO NORTE PIAUIENSE | TERESINA | OUTRAS ATIVIDADES DE SERVICOS | 22.0 | 0 | 1.0 | 1.0 | NaN | 1.0 | 0.0 | 1.0 | SERVIÇO | PI | PI | 123638.4 | 123638.4 | 1.0 | 0.0 |
| 462292 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | ENTIDADE SINDICAL | BAIXA | SERVICOS DIVERSOS | ACIMA DE 1 ANO | AZUL | 2001-12-26 | 1286.04 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 1.0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 1.0 | a29ac8a2e3a0bd8b806a7d62d135c806de7004dc088485... | 15 a 20 | 16.849315 | NaN | NaN | NaN | ENTIDADES SEM FINS LUCRATIVOS | ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS | NaN | NaN | OUTRAS ATIVIDADES DE SERVICOS | 23.0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RO | RO | 210000.0 | 210000.0 | 1.0 | 0.0 |
| 462293 | ATE R$ 81.000,00 | ATE R$ 81.000,00 | EMPRESARIO INDIVIDUAL | ALTA | COMERCIO E REPARACAO DE VEICULOS | ACIMA DE 1 ANO | VERDE | 2015-07-28 | 585.63 | 0.0 | 1 | 0 | 1 | 0 | 1 | 1.0 | 1.0 | 0.0 | 0 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 469ee5fc984d0bb60aa2f40cda4d003d7c9b963d149ed3... | 1 a 5 | 3.254795 | 31.0 | 31.000000 | 31.0 | OUTROS | COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E... | AGRESTE POTIGUAR | BORBOREMA POTIGUAR | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 22.0 | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | 1.0 | COMERCIO | RN | RN | 50000.0 | 50000.0 | 0.0 | 0.0 |
| 462294 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | MUITO BAIXA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | LARANJA | 2009-11-16 | 2429.89 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 656f496e7e2fad708f0022d8ad97d2cb9344e839a5f3cb... | 5 a 10 | 8.953425 | NaN | NaN | NaN | OUTROS | SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA | CENTRO NORTE PIAUIENSE | TERESINA | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME... | 23.0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | PI | PI | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 462295 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | ASSOCIACAO PRIVADA | MEDIA | SERVICOS DE SAUDE | ACIMA DE 1 ANO | AMARELO | 2005-11-03 | 3150.81 | 0.0 | 0 | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 1.0 | 1 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 9b933a5cf2149d1338f00fb459d34a16b9b0f2e8d3e8e1... | > 20 | 20.745205 | 74.0 | 74.000000 | 74.0 | ENTIDADES SEM FINS LUCRATIVOS | ATIVIDADES DE ATENCAO A SAUDE HUMANA | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | SAUDE HUMANA E SERVICOS SOCIAIS | 23.0 | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | 1.0 | SERVIÇO | MA | MA | 210000.0 | 210000.0 | 0.0 | 0.0 |
| 462296 | DE R$ 360.000,01 A R$ 1.500.000,00 | DE R$ 360.000,01 A R$ 1.500.000,00 | SOCIEDADE EMPRESARIA LIMITADA | ALTA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | VERDE | 2016-11-30 | 2752.49 | 0.0 | 1 | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 0.0 | 0 | 0 | 0.0 | 84db0f17467cf4f02439e01ade57150b6ac59d9dae53ed... | 1 a 5 | 1.909589 | 39.0 | 31.666667 | 25.0 | ENTIDADES EMPRESARIAIS | COMERCIO VAREJISTA | NaN | NaN | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ... | 20.0 | 0 | 5.0 | 1.0 | 2.0 | 5.0 | 0.0 | 3.0 | COMERCIO | RO | RO | 432734.4 | 432734.4 | 0.0 | 0.0 |
| 462297 | DE R$ 81.000,01 A R$ 360.000,00 | DE R$ 81.000,01 A R$ 360.000,00 | EMPRESARIO INDIVIDUAL | BAIXA | TRANSPORTE, ARMAZENAGEM E CORREIO | SEM INFORMACAO | CINZA | 2018-01-10 | NaN | 0.0 | 1 | 0 | 1 | 0 | 1 | NaN | NaN | 1.0 | 0 | 0 | 0.0 | 0.0 | 0 | 1 | 0.0 | 3d43e934e150b86be1e67524f5ba1018b27da9ef25566d... | <= 1 | 0.797260 | 44.0 | 44.000000 | 44.0 | OUTROS | CORREIO E OUTRAS ATIVIDADES DE ENTREGA | NaN | NaN | TRANSPORTE ARMAZENAGEM E CORREIO | NaN | 0 | 1.0 | NaN | 1.0 | 1.0 | 0.0 | 1.0 | SERVIÇO | RO | RO | 210000.0 | 210000.0 | 0.0 | 0.0 |